1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Views
12 {
13 public delegate void LinkBatDau_BanHang_EventHandler(object sender, EventArgs e);
14
15 public delegate void LinkBatDau_NhapHang_EventHandler(object sender, EventArgs e);
16
17 public delegate void LinkBC_KhoaSoNgayHomNay_EventHandler(object sender, EventArgs e, DateTime dayHome);
18
19 public delegate void LinkBC_Tong_DonHangTrongNgay_EventHandler(object sender, EventArgs e, DateTime dayHome);
20
21
22 public delegate void LinkBC_Tong_MatHang_EventHandler(object sender, EventArgs e, DateTime dayHome);
23
24
25 public delegate void LinkBC_Tong_DoanhThu_EventHandler(object sender, EventArgs e, DateTime dayHome);
26
27
28 public delegate void LinkBC_Tong_LoiNhuan_EventHandler(object sender, EventArgs e, DateTime dayHome);
29
30 public delegate void Link_CauHinh_EventHandler(object sender, EventArgs e);
31
32 public delegate void Link_BOM_VaGoiSanPham_EventHandler(object sender, EventArgs e);
33
34 public delegate void Link_NhaCc_Dashboard_EventHandler(object sender, EventArgs e);
35
36 public delegate void Link_ThuChi_Dashboard_EventHandler(object sender, EventArgs e);
37
38 public delegate void Link_QuanLyKho_Dashboard_EventHandler(object sender, EventArgs e);
39
40
41 public delegate void Link_CNo_Dashboard_EventHandler(object sender, EventArgs e);
42
43 public delegate void Link_LapBaoCao_Dashboard_EventHandler(object sender, EventArgs e);
44
45 public partial class uctDashboard : UserControl
46 {
47 public uctDashboard()
48 {
49 InitializeComponent();
50 //this.displayData_There = displayData_There; //assign passed in delegate
51 }
52
53 public static uctDashboard uctDB = new uctDashboard();
54
55
56 public event LinkBatDau_BanHang_EventHandler Link_BatDau_BanHang;
57
58 public event LinkBatDau_NhapHang_EventHandler Link_BatDau_NhapHang;
59
60 public event LinkBC_KhoaSoNgayHomNay_EventHandler Link_BC_KhoaSoNgayHomNay;
61
62 public event LinkBC_Tong_DonHangTrongNgay_EventHandler Link_BC_Tong_DonHang;
63
64 public event LinkBC_Tong_MatHang_EventHandler Link_BC_Tong_MatHang;
65
66 public event LinkBC_Tong_DoanhThu_EventHandler Link_BC_Tong_DoanhThu;
67
68 public event LinkBC_Tong_LoiNhuan_EventHandler Link_BC_Tong_LoiNhuan;
69
70
71
72 public event Link_CauHinh_EventHandler Link_CauHinh;
73
74
75 public event Link_BOM_VaGoiSanPham_EventHandler Link_BOM_VaGoiSanPham;
76
77 public event Link_NhaCc_Dashboard_EventHandler Link_NhaCc_Dashboard;
78
79 public event Link_ThuChi_Dashboard_EventHandler Link_ThuChi_Dashboard;
80
81 public event Link_QuanLyKho_Dashboard_EventHandler Link_QuanLyKho_Dashboard;
82
83
84 public event Link_CNo_Dashboard_EventHandler Link_CNo_Dashboard;
85
86 public event Link_LapBaoCao_Dashboard_EventHandler Link_LapBaoCao_Dashboard;
87
88 int _idKhachHang = 0;
89 string _tenKhachHang = string.Empty;
90 string _soDienThoai = string.Empty;
91 string _diaChi = string.Empty;
92 int _trangThai = 1;
93 double _diemTichLuy = 0;
94 double _tongTien = 0;
95 double _tienKhach = 0;
96 double _tienTraLai = 0;
97 DateTime _ngayMuaHang = DateTime.Now;
98 string _ghiChu = string.Empty;
99 string _TrangThaiGiaoDich = string.Empty;
100
101 //int _pageSize = 30;
102 //int _pageIndex = 1;
103 //int _tongSoBanGhi = 0;
104 //int _stt = 0;
105
106
107 private void linkLabel_BaoCaoKhoSoNgayHomNay_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
108 {
109 if (this.Link_BC_KhoaSoNgayHomNay != null)
110 {
111 this.Link_BC_KhoaSoNgayHomNay(sender, e, DateTime.Now);
112 }
113
114 }
115
116 private void linkLabel_BatDauBanHang_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
117 {
118 if (this.Link_BatDau_BanHang != null)
119 {
120 this.Link_BatDau_BanHang(sender, e);
121 }
122 }
123
124 private void linkLabel_BatDauNhapHang_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
125 {
126 if (this.Link_BatDau_NhapHang != null)
127 {
128 this.Link_BatDau_NhapHang(sender, e);
129 }
130 }
131
132 private void linkLabel_CT_TongMatHang_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
133 {
134 if (this.Link_BC_Tong_MatHang != null)
135 {
136 this.Link_BC_Tong_MatHang(sender, e, DateTime.Now);
137 }
138 }
139
140 private void linkLabel_CT_TongDoanhThu_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
141 {
142 if (this.Link_BC_Tong_DoanhThu != null)
143 {
144 this.Link_BC_Tong_DoanhThu(sender, e, DateTime.Now);
145 }
146 }
147
148 private void linkLabel_CT_LoiNhuan_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
149 {
150 if (this.Link_BC_Tong_LoiNhuan != null)
151 {
152 this.Link_BC_Tong_LoiNhuan(sender, e, DateTime.Now);
153 }
154 }
155
156 private void linkLabel_CT_TongDH_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
157 {
158 DateTime dayHomeN = DateTime.Now;
159
160 if (this.Link_BC_Tong_DonHang != null)
161 {
162 this.Link_BC_Tong_DonHang(sender, e, dayHomeN);
163 }
164 }
165
166 //private void HienThiTongDonHang()
167 //{
168
169 //}
170
171 //private void HienThiTongMatHang()
172 //{
173
174
175 //}
176
177
178 private void uctDashboard_Load(object sender, EventArgs e)
179 {
180 // if (CauHinhHeThong.KET_NOI_CSDL == true)
181 //{
182 //this.HienThiTongDonHang();
183
184 //this.HienThiTongMatHang();
185 //this.HienThiTrangDashboard();
186 //}
187
188 }
189
190 private void linkLabel_CauHinh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
191 {
192 if (this.Link_CauHinh != null)
193 {
194 this.Link_CauHinh(sender, e);
195 }
196 }
197
198 public void HienThiTrangDashboard()
199 {
200
201 DataTable dtKh = new DataTable();
202
203 dtKh = Controllers.KhachHangCtrl_tbl.FillDataSet_KhachHang_Count_ByNgayMua(_idKhachHang, _tenKhachHang, _soDienThoai, _diaChi, _trangThai, _diemTichLuy, _tongTien, _tienKhach, _tienTraLai, _ngayMuaHang, _ghiChu, _TrangThaiGiaoDich).Tables[0];
204
205 if (dtKh.Rows.Count > 0)
206 {
207 txtTongDonHang.Text = dtKh.Rows[0]["TongDonHang"].ToString();
208 }
209 else
210 {
211 txtTongDonHang.Text = "0";
212 }
213
214 //
215
216 DataTable dtBh = new DataTable();
217
218 dtBh = Controllers.BanHangCtrl.FillDataSet_BanHang_CountMatHang_byKhachHangId("", 0, 1, DateTime.Now).Tables[0];
219
220 if (dtBh.Rows.Count > 0)
221 {
222 txtTongMatHang.Text = dtBh.Rows[0]["TongMatHang"].ToString();
223 }
224 else
225 {
226 txtTongMatHang.Text = "0";
227 }
228
229 //doanh thu, loi nhuan
230 //cong no thu chi
231 DateTime ngayLamViec = DateTime.Now;
232 double tongThuBanHang_VaCongNoThu = 0;
233 double tongChiNhapHang_VaCongNoChi = 0;
234
235 double congNoThu = 0;
236 double congNoChi = 0;
237
238 DataTable dtThuCn = new DataTable();
239
240 dtThuCn = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "").Tables[2];
241
242 if (dtThuCn.Rows.Count > 0)
243 {
244 congNoThu = CauHinhHeThong.Format_SoDeTinhToan(dtThuCn.Rows[0]["TongCongNoThu"].ToString(), false);
245 tongThuBanHang_VaCongNoThu = CauHinhHeThong.Format_SoDeTinhToan(dtThuCn.Rows[0]["TongTienThuBanHang"].ToString(), false);
246 }
247 else
248 {
249 congNoThu = 0;
250 tongThuBanHang_VaCongNoThu = 0;
251 }
252
253 double tongCongNoThu = tongThuBanHang_VaCongNoThu + congNoThu;
254
255 DataTable dtChiCn = new DataTable();
256 dtChiCn = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "").Tables[3];
257
258 if (dtChiCn.Rows.Count > 0)
259 {
260 congNoChi = CauHinhHeThong.Format_SoDeTinhToan(dtChiCn.Rows[0]["TongCongNoChi"].ToString(), false);
261 tongChiNhapHang_VaCongNoChi = CauHinhHeThong.Format_SoDeTinhToan(dtChiCn.Rows[0]["TongTienDaThanhToanNhapHang"].ToString(), false);
262 }
263 else
264 {
265 congNoChi = 0;
266 tongChiNhapHang_VaCongNoChi = 0;
267 }
268
269 double tongCongNoChi = tongChiNhapHang_VaCongNoChi + congNoChi;
270
271 double tongDoanhThu = (tongThuBanHang_VaCongNoThu + congNoThu) - (congNoChi + tongChiNhapHang_VaCongNoChi);
272
273 txtTongDoanhThu.Text = CauHinhHeThong.Format_SoDeHienThi(tongDoanhThu, true);
274
275 DataTable dtDtLoiNhuan = new DataTable();
276 dtDtLoiNhuan = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "").Tables[4];
277 if (dtDtLoiNhuan.Rows.Count > 0)
278 {
279 double tongGiaNhap = 0;
280 tongGiaNhap = CauHinhHeThong.Format_SoDeTinhToan(dtDtLoiNhuan.Rows[0]["TongGiaNhapHang"].ToString(), false);
281
282 double LoiNhuan = tongThuBanHang_VaCongNoThu - tongGiaNhap;
283
284 txtTongLoiNhuan.Text = CauHinhHeThong.Format_SoDeHienThi(LoiNhuan, true);
285 }
286 else
287 {
288 txtTongLoiNhuan.Text = "0";
289 }
290 }
291
292 private void linkLabelBomVaGoiSanPham_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
293 {
294 if (this.Link_BOM_VaGoiSanPham != null)
295 {
296 this.Link_BOM_VaGoiSanPham(sender, e);
297 }
298 }
299
300 private void linkLabelNhaCungCap_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
301 {
302 if (this.Link_NhaCc_Dashboard != null)
303 {
304 this.Link_NhaCc_Dashboard(sender, e);
305 }
306 }
307
308 private void linkLabel4DsThuChi_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
309 {
310 if (this.Link_ThuChi_Dashboard != null)
311 {
312 this.Link_ThuChi_Dashboard(sender, e);
313 }
314 }
315
316 private void linkLabel5QuanLyKho_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
317 {
318 if (this.Link_QuanLyKho_Dashboard != null)
319 {
320 this.Link_QuanLyKho_Dashboard(sender, e);
321 }
322 }
323
324 private void linkLabel2dbBaoCao_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
325 {
326 if (this.Link_LapBaoCao_Dashboard != null)
327 {
328 this.Link_LapBaoCao_Dashboard(sender, e);
329 }
330 }
331
332 private void linkLabel1DbCongNo_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
333 {
334 if (this.Link_CNo_Dashboard != null)
335 {
336 this.Link_CNo_Dashboard(sender, e);
337 }
338 }
339 //
340
341 }
342 }
